﻿/*
SQLyog Ultimate v11.24 (32 bit)
MySQL - 5.6.24 : Database - yjz
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
use yjz_prod;

-- ----------------------------
--  Records of `users`
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES ('admin', 'fb49ae1f4ff525971dce997fe84aa3ac4db3d9fd308f11f6153d4d7d9d9ab53c895ef246839cff0a', '1');
COMMIT;

-- ----------------------------
--  Records of `authorities`
-- ----------------------------
BEGIN;
INSERT INTO `authorities` VALUES ('admin', 'ROLE_ADMIN'), ('sanlli', 'ROLE_USER');
COMMIT;

-- ----------------------------
--  Records of `account_subject_template`
-- ----------------------------
BEGIN;
INSERT INTO `account_subject_template` VALUES (1,-1,'资产',-9999,-1,NULL,1,'2015-09-28 11:14:00','2015-01-01 00:00:00'),(2,-2,'负债',-9999,-1,NULL,1,'2015-09-28 11:14:00','2015-01-01 00:00:00'),(3,-3,'共同',-9999,-1,NULL,1,'2015-09-28 11:14:00','2015-01-01 00:00:00'),(4,-4,'权益',-9999,-1,NULL,1,'2015-09-28 11:14:00','2015-01-01 00:00:00'),(5,-5,'成本',-9999,-1,NULL,1,'2015-09-28 11:14:00','2015-01-01 00:00:00'),(6,-6,'损益',-9999,-1,NULL,1,'2015-09-28 11:14:00','2015-01-01 00:00:00'),(313,-7,'现金',-1,0,NULL,1,'2015-09-28 11:14:33','2015-01-01 00:00:00'),(314,-8,'银行存款',-1,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:15:13'),(315,-9,'流动资产',-1,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:15:17'),(316,-10,'坏账准备',-1,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:15:22'),(317,-11,'存货',-1,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:15:26'),(318,-12,'非流动资产',-1,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:16:15'),(319,-13,'固定资产',-1,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:16:18'),(320,-14,'累计折旧',-1,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:16:21'),(321,-15,'流动负债',-2,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:16:24'),(322,-16,'非流动负债',-2,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:16:28'),(323,-17,'共同',-3,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:16:31'),(324,-18,'资本',-4,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:16:35'),(325,-19,'累计盈余',-4,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:16:38'),(326,-20,'生产成本',-5,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:16:42'),(327,-21,'收入',-6,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:16:45'),(328,-22,'其他收入',-6,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:16:48'),(329,-23,'销售成本',-6,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:16:51'),(330,-24,'其他费用',-6,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:16:54'),(331,-25,'费用',-6,0,NULL,1,'2015-09-28 11:14:33','2015-09-28 11:16:59'),(599,1001,'库存现金',-7,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(600,1002,'银行存款',-8,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(601,1012,'其他货币资金',-9,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(602,101201,'外埠存款',1012,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(603,101202,'银行本票存款',1012,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(604,101203,'银行汇票存款',1012,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(605,101204,'信用卡存款',1012,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(606,101205,'信用保证金存款',1012,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(607,101206,'存出投资款',1012,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(608,1101,'交易性金融资产',-9,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(609,110101,'本金',1101,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(610,11010101,'股票',110101,3,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(611,11010102,'债券',110101,3,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(612,11010103,'基金',110101,3,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(613,11010104,'权证',110101,3,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(614,11010199,'其他',110101,3,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(615,110102,'公允价值变动',1101,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(616,11010201,'股票',110102,3,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(617,11010202,'债券',110102,3,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(618,11010203,'基金',110102,3,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(619,11010204,'权证',110102,3,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(620,11010299,'其他',110102,3,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(621,1121,'应收票据',-9,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(622,1122,'应收账款',-9,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(623,1123,'预付账款',-9,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(624,1131,'应收股利',-9,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(625,1132,'应收利息',-9,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(626,1221,'其他应收款',-9,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(627,1231,'坏账准备',-10,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(628,123101,'应收账款坏账准备',1231,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(629,123102,'其他应收账款坏账准备',1231,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(630,1321,'受托代销商品',-11,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(631,1401,'材料采购',-11,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(632,1402,'在途物资',-11,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(633,1403,'原材料',-11,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(634,1404,'材料成本差异',-11,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(635,1405,'库存商品',-11,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(636,1406,'发出商品',-11,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(637,1407,'商品进销差价',-11,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(638,1408,'委托加工物资',-11,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(639,1411,'周转材料',-11,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(640,1471,'存货跌价准备',-11,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(641,1501,'持有至到期投资',-12,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(642,150101,'投资成本',1501,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(643,150102,'溢折价',1501,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(644,150103,'应计利息',1501,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(645,1502,'持有至到期投资减值准备',-12,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(646,1503,'可供出售金融资产',-12,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(647,1511,'长期股权投资',-12,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(648,151101,'投资成本',1511,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(649,151102,'损益调整',1511,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(650,151103,'所有者权益其他变动',1511,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(651,1512,'长期股权投资减值准备',-12,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(652,1521,'投资性房地产',-12,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(653,152101,'成本',1521,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(654,152102,'公允价值变动',1521,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(655,1531,'长期应收款',-12,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(656,1532,'未实现融资收益',-12,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(657,1601,'固定资产',-13,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(658,1602,'累计折旧',-14,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(659,1603,'固定资产减值准备',-13,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(660,1604,'在建工程',-13,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(661,160401,'建筑工程',1604,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(662,160402,'安装工程',1604,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(663,160403,'在安装设备',1604,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(664,160404,'待摊支出',1604,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(665,1605,'工程物资',-13,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(666,160501,'专用材料',1605,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(667,160502,'专用设备',1605,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(668,160503,'预付大型设备款',1605,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(669,160504,'为生产准备的工具及器具',1605,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(670,1606,'固定资产清理',-13,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(671,1701,'无形资产',-12,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(672,1702,'累计摊销',-12,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(673,1703,'无形资产减值准备',-12,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(674,1711,'商誉',-12,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(675,1801,'长期待摊费用',-12,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(676,1811,'递延所得税资产',-12,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(677,1901,'待处理财产损益',-12,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(678,2001,'短期借款',-15,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(679,2101,'交易性金融负债',-15,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(680,210101,'本金',2101,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(681,210102,'公允价值变动',2101,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(682,2201,'应付票据',-15,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(683,2202,'应付账款',-15,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(684,2203,'预收账款',-15,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(685,2211,'应付职工薪酬',-15,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(686,221101,'工资',2211,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(687,221102,'职工福利',2211,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(688,221103,'社会保险费',2211,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(689,221104,'住房公积金',2211,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(690,221105,'工会经费',2211,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(691,221106,'职工教育经费',2211,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(692,221107,'解除职工劳动关系补偿',2211,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(693,2221,'应交税费',-15,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(694,222101,'应交增值税',2221,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(695,22210101,'进项税额',222101,3,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(696,22210102,'已交税金',222101,3,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(697,22210103,'减免税款',222101,3,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(698,22210104,'出口抵减内销产品应纳税额',222101,3,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(699,22210105,'转出未交增值税',222101,3,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(700,22210106,'销项税额',222101,3,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(701,22210107,'出口退税',222101,3,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(702,22210108,'进项税额转出',222101,3,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(703,22210109,'转出多交增值税',222101,3,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(704,222102,'未交增值税',2221,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(705,222103,'应交营业税',2221,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(706,222104,'应交消费税',2221,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(707,222105,'应交资源税',2221,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(708,222106,'应交所得税',2221,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(709,222107,'应交土地增值税',2221,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(710,222108,'应交城市建设维护税',2221,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(711,222109,'应交教育附加费',2221,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(712,222110,'应交房产税',2221,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(713,222111,'应交土地使用税',2221,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(714,222112,'应交车船使用税',2221,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(715,222113,'应交个人所得税',2221,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(716,222114,'应交矿产资源补偿费',2221,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(717,2231,'应付股利',-15,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(718,2232,'应付利息',-15,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(719,2241,'其他应付款',-15,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(720,2314,'受托代销商品款',-15,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(721,2401,'递延收益',-15,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(722,2501,'长期借款',-16,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(723,250101,'本金',2501,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(724,250102,'利息调整',2501,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(725,2502,'应付债券',-16,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(726,250201,'债券面值',2502,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(727,250202,'利息调整',2502,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(728,250203,'应计利息',2502,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(729,2701,'长期应付款',-16,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(730,2702,'未确认融资费用',-16,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(731,2711,'专项应付款',-16,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(732,2801,'预计负债',-15,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(733,2901,'递延所得税负债',-16,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(734,3101,'衍生工具',-17,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(735,3201,'套期工具',-17,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(736,3202,'被套期项目',-17,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(737,4001,'实收资本',-18,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(738,4002,'资本公积',-18,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(739,400201,'资本溢价',4002,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(740,400202,'股本溢价',4002,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(741,400203,'其他资本公积',4002,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(742,4101,'盈余公积',-18,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(743,410101,'法定盈余公积',4101,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(744,410102,'任意盈余公积',4101,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(745,410103,'法定公益金',4101,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(746,410104,'储备基金',4101,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(747,410105,'企业发展基金',4101,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(748,410106,'利润归还投资',4101,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(749,4103,'本年利润',-19,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(750,4104,'利润分配',-19,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(751,410401,'提取法定盈余公积金',4104,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(752,410402,'提取任意盈余公积',4104,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(753,410403,'提取法定公益金',4104,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(754,410404,'应付现金股利或利润',4104,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(755,410405,'转作股本的利润',4104,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(756,410406,'盈余公积补亏',4104,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(757,410407,'提取储备基金',4104,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(758,410408,'提取企业发展基金',4104,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(759,410409,'提取职工奖励及福利基金',4104,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(760,410410,'利润归还投资',4104,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(761,410411,'未分配利润',4104,2,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(762,4201,'库存股',-19,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(763,5001,'生产成本',-20,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(764,500101,'基本生产成本',5001,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(765,500102,'辅助生产成本',5001,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(766,5101,'制造费用',-20,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(767,5201,'劳务成本',-20,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(768,5301,'研发支出',-20,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(769,530101,'费用化支出',5301,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(770,530102,'资本化支出',5301,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(771,6001,'主营业务收入',-21,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(772,6051,'其他业务收入',-22,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(773,6101,'公允价值变动损益',-22,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(774,6111,'投资收益',-22,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(775,6301,'营业外收入',-22,1,2,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(776,6401,'主营业务成本',-23,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(777,6402,'其他业务成本',-24,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(778,6403,'营业税金及附加',-24,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(779,6601,'销售费用',-25,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(780,660101,'办公用品',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(781,660102,'房租',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(782,660103,'物业管理费',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(783,660104,'水电费',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(784,660105,'交际应酬费',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(785,660106,'市内交通费',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(786,660107,'差旅费',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(787,660108,'补助',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(788,660109,'通讯费',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(789,660110,'工资',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(790,660111,'佣金',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(791,660112,'保险金',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(792,660113,'福利费',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(793,660114,'包装费',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(794,660115,'展览费费和广告费',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(795,660116,'商品维修费',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(796,660117,'预计产品质量保证损失',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(797,660118,'运输费',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(798,660119,'装卸费',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(799,660120,'折旧费',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(800,660121,'计提福利',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(801,660122,'计提职工教育经费',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(802,660199,'其他',6601,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(803,6602,'管理费用',-25,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(804,660201,'办公用品',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(805,660202,'房租',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(806,660203,'物业管理费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(807,660204,'水电费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(808,660205,'交际应酬费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(809,660206,'市内交通费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(810,660207,'差旅费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(811,660208,'通讯费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(812,660209,'工资',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(813,660210,'保险金',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(814,660211,'福利费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(815,660212,'工会经费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(816,660213,'董事会费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(817,660214,'聘请中介机构费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(818,660215,'咨询费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(819,660216,'诉讼费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(820,660217,'房产税',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(821,660218,'车船使用税',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(822,660219,'土地使用税',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(823,660220,'印花税',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(824,660221,'技术转让费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(825,660222,'矿产资源补偿费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(826,660223,'研究费用',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(827,660224,'排污费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(828,660225,'折旧费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(829,660226,'计提福利',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(830,660227,'计提职工教育经费',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(831,660228,'存货盘亏或盘盈',6602,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(832,6603,'财务费用',-25,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(833,660301,'汇兑损益',6603,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(834,660302,'利息',6603,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(835,660303,'手续费',6603,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(836,660399,'其他',6603,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(837,6701,'资产减值损失',-24,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(838,6711,'营业外支出',-24,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(839,6801,'所得税费用',-24,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(840,680101,'当期所得税费用',6801,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(841,680102,'递延所得税费用',6801,2,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00'),(842,6901,'以前年度损益调整',-24,1,1,1,'2015-09-28 11:21:24','2015-01-01 00:00:00');
COMMIT;

-- ----------------------------
--  Records of `company_common_type`
-- ----------------------------
BEGIN;
INSERT INTO `company_common_type` VALUES ('1', '1', '凭证字', null, '2015-09-26 22:07:11', '2015-01-01 00:00:00'), ('2', '2', '模式类别', null, '2015-10-23 10:46:36', '2015-01-01 00:00:00');
COMMIT;

-- ----------------------------
--  Records of `company_common_value`
-- ----------------------------
BEGIN;
INSERT INTO `company_common_value` VALUES ('1', '1', '记', '记', null, '2015-09-26 22:07:27', '2015-01-01 00:00:00'), ('2', '1', '录', '录', null, '2015-09-26 22:07:37', '2015-01-01 00:00:00');
COMMIT;

-- ----------------------------
--  Records of `dict_type`
-- ----------------------------
BEGIN;
INSERT INTO `dict_type` VALUES ('1', 'kjkmtx', '会计科目体系', '2015-09-23 09:55:27', '2015-01-01 00:00:00');
COMMIT;

-- ----------------------------
--  Records of `dict_value`
-- ----------------------------
BEGIN;
INSERT INTO `dict_value` VALUES ('1', '1', '`2015新会计准则`', '2015新会计准则', '1', '2015-09-23 09:58:41', '2015-01-01 00:00:00');
COMMIT;

-- 演示账套数据 ---
-- ----------------------------
--  Records of `account_book`
-- ----------------------------
BEGIN;
INSERT INTO `account_book` VALUES ('1', '演示账套', 'RMB', '人民币', '2015-10-01', '2015', '10', '安徽新华社', null, '1', '0', '2015-10-22 15:54:56', '2015-01-01 00:00:00','1');
COMMIT;

-- ----------------------------
--  Records of `period`
-- ----------------------------
BEGIN;
INSERT INTO `period` VALUES ('1', '2015-10-01 00:00:00', null, '10', '1', '1', null, '0', '2015-10-22 15:54:56', '2015-01-01 00:00:00');
COMMIT;

-- ----------------------------
--  Records of `subject_length`
-- ----------------------------
BEGIN;
INSERT INTO `subject_length` VALUES ('1', '4', '1', '1', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('2', '2', '2', '1', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('3', '2', '3', '1', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('4', '2', '4', '1', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('5', '2', '5', '1', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00');
COMMIT;

-- ----------------------------
--  Records of `account_subject`
-- ----------------------------
BEGIN;
INSERT INTO `account_subject` VALUES ('1', '-1', '资产', '-9999', '-1', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('2', '-2', '负债', '-9999', '-1', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('3', '-3', '共同', '-9999', '-1', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('4', '-4', '权益', '-9999', '-1', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('5', '-5', '成本', '-9999', '-1', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('6', '-6', '损益', '-9999', '-1', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('7', '-7', '现金', '-1', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('8', '-8', '银行存款', '-1', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('9', '-9', '流动资产', '-1', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('10', '-10', '坏账准备', '-1', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('11', '-11', '存货', '-1', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('12', '-12', '非流动资产', '-1', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('13', '-13', '固定资产', '-1', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('14', '-14', '累计折旧', '-1', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('15', '-15', '流动负债', '-2', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('16', '-16', '非流动负债', '-2', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('17', '-17', '共同', '-3', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('18', '-18', '资本', '-4', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('19', '-19', '累计盈余', '-4', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('20', '-20', '生产成本', '-5', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('21', '-21', '收入', '-6', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('22', '-22', '其他收入', '-6', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('23', '-23', '销售成本', '-6', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('24', '-24', '其他费用', '-6', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('25', '-25', '费用', '-6', '0', null, null, '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('26', '1001', '库存现金', '-7', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('27', '1002', '银行存款', '-8', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('28', '1012', '其他货币资金', '-9', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('29', '101201', '外埠存款', '1012', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('30', '101202', '银行本票存款', '1012', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('31', '101203', '银行汇票存款', '1012', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('32', '101204', '信用卡存款', '1012', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('33', '101205', '信用保证金存款', '1012', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('34', '101206', '存出投资款', '1012', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('35', '1101', '交易性金融资产', '-9', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('36', '110101', '本金', '1101', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('37', '11010101', '股票', '110101', '3', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('38', '11010102', '债券', '110101', '3', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('39', '11010103', '基金', '110101', '3', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('40', '11010104', '权证', '110101', '3', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('41', '11010199', '其他', '110101', '3', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('42', '110102', '公允价值变动', '1101', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('43', '11010201', '股票', '110102', '3', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('44', '11010202', '债券', '110102', '3', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('45', '11010203', '基金', '110102', '3', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('46', '11010204', '权证', '110102', '3', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('47', '11010299', '其他', '110102', '3', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('48', '1121', '应收票据', '-9', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('49', '1122', '应收账款', '-9', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('50', '1123', '预付账款', '-9', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('51', '1131', '应收股利', '-9', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('52', '1132', '应收利息', '-9', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('53', '1221', '其他应收款', '-9', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('54', '1231', '坏账准备', '-10', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('55', '123101', '应收账款坏账准备', '1231', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('56', '123102', '其他应收账款坏账准备', '1231', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('57', '1321', '受托代销商品', '-11', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('58', '1401', '材料采购', '-11', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('59', '1402', '在途物资', '-11', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('60', '1403', '原材料', '-11', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('61', '1404', '材料成本差异', '-11', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('62', '1405', '库存商品', '-11', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('63', '1406', '发出商品', '-11', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('64', '1407', '商品进销差价', '-11', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('65', '1408', '委托加工物资', '-11', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('66', '1411', '周转材料', '-11', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('67', '1471', '存货跌价准备', '-11', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('68', '1501', '持有至到期投资', '-12', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('69', '150101', '投资成本', '1501', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('70', '150102', '溢折价', '1501', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('71', '150103', '应计利息', '1501', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('72', '1502', '持有至到期投资减值准备', '-12', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('73', '1503', '可供出售金融资产', '-12', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('74', '1511', '长期股权投资', '-12', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('75', '151101', '投资成本', '1511', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('76', '151102', '损益调整', '1511', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('77', '151103', '所有者权益其他变动', '1511', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('78', '1512', '长期股权投资减值准备', '-12', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('79', '1521', '投资性房地产', '-12', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('80', '152101', '成本', '1521', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('81', '152102', '公允价值变动', '1521', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('82', '1531', '长期应收款', '-12', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('83', '1532', '未实现融资收益', '-12', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('84', '1601', '固定资产', '-13', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('85', '1602', '累计折旧', '-14', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('86', '1603', '固定资产减值准备', '-13', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('87', '1604', '在建工程', '-13', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('88', '160401', '建筑工程', '1604', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('89', '160402', '安装工程', '1604', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('90', '160403', '在安装设备', '1604', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('91', '160404', '待摊支出', '1604', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('92', '1605', '工程物资', '-13', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('93', '160501', '专用材料', '1605', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('94', '160502', '专用设备', '1605', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('95', '160503', '预付大型设备款', '1605', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('96', '160504', '为生产准备的工具及器具', '1605', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('97', '1606', '固定资产清理', '-13', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('98', '1701', '无形资产', '-12', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('99', '1702', '累计摊销', '-12', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('100', '1703', '无形资产减值准备', '-12', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('101', '1711', '商誉', '-12', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('102', '1801', '长期待摊费用', '-12', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('103', '1811', '递延所得税资产', '-12', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('104', '1901', '待处理财产损益', '-12', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('105', '2001', '短期借款', '-15', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('106', '2101', '交易性金融负债', '-15', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('107', '210101', '本金', '2101', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('108', '210102', '公允价值变动', '2101', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('109', '2201', '应付票据', '-15', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('110', '2202', '应付账款', '-15', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('111', '2203', '预收账款', '-15', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('112', '2211', '应付职工薪酬', '-15', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('113', '221101', '工资', '2211', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('114', '221102', '职工福利', '2211', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('115', '221103', '社会保险费', '2211', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('116', '221104', '住房公积金', '2211', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('117', '221105', '工会经费', '2211', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('118', '221106', '职工教育经费', '2211', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('119', '221107', '解除职工劳动关系补偿', '2211', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('120', '2221', '应交税费', '-15', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('121', '222101', '应交增值税', '2221', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('122', '22210101', '进项税额', '222101', '3', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('123', '22210102', '已交税金', '222101', '3', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('124', '22210103', '减免税款', '222101', '3', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('125', '22210104', '出口抵减内销产品应纳税额', '222101', '3', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('126', '22210105', '转出未交增值税', '222101', '3', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('127', '22210106', '销项税额', '222101', '3', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('128', '22210107', '出口退税', '222101', '3', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('129', '22210108', '进项税额转出', '222101', '3', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('130', '22210109', '转出多交增值税', '222101', '3', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('131', '222102', '未交增值税', '2221', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('132', '222103', '应交营业税', '2221', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('133', '222104', '应交消费税', '2221', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('134', '222105', '应交资源税', '2221', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('135', '222106', '应交所得税', '2221', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('136', '222107', '应交土地增值税', '2221', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('137', '222108', '应交城市建设维护税', '2221', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('138', '222109', '应交教育附加费', '2221', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('139', '222110', '应交房产税', '2221', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('140', '222111', '应交土地使用税', '2221', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('141', '222112', '应交车船使用税', '2221', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('142', '222113', '应交个人所得税', '2221', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('143', '222114', '应交矿产资源补偿费', '2221', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('144', '2231', '应付股利', '-15', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('145', '2232', '应付利息', '-15', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('146', '2241', '其他应付款', '-15', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('147', '2314', '受托代销商品款', '-15', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('148', '2401', '递延收益', '-15', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('149', '2501', '长期借款', '-16', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('150', '250101', '本金', '2501', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('151', '250102', '利息调整', '2501', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('152', '2502', '应付债券', '-16', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('153', '250201', '债券面值', '2502', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('154', '250202', '利息调整', '2502', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('155', '250203', '应计利息', '2502', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('156', '2701', '长期应付款', '-16', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('157', '2702', '未确认融资费用', '-16', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('158', '2711', '专项应付款', '-16', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('159', '2801', '预计负债', '-15', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('160', '2901', '递延所得税负债', '-16', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('161', '3101', '衍生工具', '-17', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('162', '3201', '套期工具', '-17', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('163', '3202', '被套期项目', '-17', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('164', '4001', '实收资本', '-18', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('165', '4002', '资本公积', '-18', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('166', '400201', '资本溢价', '4002', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('167', '400202', '股本溢价', '4002', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('168', '400203', '其他资本公积', '4002', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('169', '4101', '盈余公积', '-18', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('170', '410101', '法定盈余公积', '4101', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('171', '410102', '任意盈余公积', '4101', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('172', '410103', '法定公益金', '4101', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('173', '410104', '储备基金', '4101', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('174', '410105', '企业发展基金', '4101', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('175', '410106', '利润归还投资', '4101', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('176', '4103', '本年利润', '-19', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('177', '4104', '利润分配', '-19', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('178', '410401', '提取法定盈余公积金', '4104', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('179', '410402', '提取任意盈余公积', '4104', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('180', '410403', '提取法定公益金', '4104', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('181', '410404', '应付现金股利或利润', '4104', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('182', '410405', '转作股本的利润', '4104', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('183', '410406', '盈余公积补亏', '4104', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('184', '410407', '提取储备基金', '4104', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('185', '410408', '提取企业发展基金', '4104', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('186', '410409', '提取职工奖励及福利基金', '4104', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('187', '410410', '利润归还投资', '4104', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('188', '410411', '未分配利润', '4104', '2', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('189', '4201', '库存股', '-19', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('190', '5001', '生产成本', '-20', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('191', '500101', '基本生产成本', '5001', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('192', '500102', '辅助生产成本', '5001', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('193', '5101', '制造费用', '-20', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('194', '5201', '劳务成本', '-20', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('195', '5301', '研发支出', '-20', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('196', '530101', '费用化支出', '5301', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('197', '530102', '资本化支出', '5301', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('198', '6001', '主营业务收入', '-21', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('199', '6051', '其他业务收入', '-22', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('200', '6101', '公允价值变动损益', '-22', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('201', '6111', '投资收益', '-22', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('202', '6301', '营业外收入', '-22', '1', null, '2', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('203', '6401', '主营业务成本', '-23', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('204', '6402', '其他业务成本', '-24', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('205', '6403', '营业税金及附加', '-24', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('206', '6601', '销售费用', '-25', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('207', '660101', '办公用品', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('208', '660102', '房租', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('209', '660103', '物业管理费', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('210', '660104', '水电费', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('211', '660105', '交际应酬费', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('212', '660106', '市内交通费', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('213', '660107', '差旅费', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('214', '660108', '补助', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('215', '660109', '通讯费', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('216', '660110', '工资', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('217', '660111', '佣金', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('218', '660112', '保险金', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('219', '660113', '福利费', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('220', '660114', '包装费', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('221', '660115', '展览费费和广告费', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('222', '660116', '商品维修费', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('223', '660117', '预计产品质量保证损失', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('224', '660118', '运输费', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('225', '660119', '装卸费', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('226', '660120', '折旧费', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('227', '660121', '计提福利', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('228', '660122', '计提职工教育经费', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('229', '660199', '其他', '6601', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('230', '6602', '管理费用', '-25', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('231', '660201', '办公用品', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('232', '660202', '房租', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('233', '660203', '物业管理费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('234', '660204', '水电费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('235', '660205', '交际应酬费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('236', '660206', '市内交通费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('237', '660207', '差旅费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('238', '660208', '通讯费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('239', '660209', '工资', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('240', '660210', '保险金', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('241', '660211', '福利费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('242', '660212', '工会经费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('243', '660213', '董事会费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('244', '660214', '聘请中介机构费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('245', '660215', '咨询费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('246', '660216', '诉讼费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('247', '660217', '房产税', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('248', '660218', '车船使用税', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('249', '660219', '土地使用税', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('250', '660220', '印花税', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('251', '660221', '技术转让费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('252', '660222', '矿产资源补偿费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('253', '660223', '研究费用', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('254', '660224', '排污费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('255', '660225', '折旧费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('256', '660226', '计提福利', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('257', '660227', '计提职工教育经费', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('258', '660228', '存货盘亏或盘盈', '6602', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('259', '6603', '财务费用', '-25', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('260', '660301', '汇兑损益', '6603', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('261', '660302', '利息', '6603', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('262', '660303', '手续费', '6603', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('263', '660399', '其他', '6603', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('264', '6701', '资产减值损失', '-24', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('265', '6711', '营业外支出', '-24', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('266', '6801', '所得税费用', '-24', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('267', '680101', '当期所得税费用', '6801', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('268', '680102', '递延所得税费用', '6801', '2', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00'), ('269', '6901', '以前年度损益调整', '-24', '1', null, '1', '1', null, null, null, null, '0', '0', null, '2015-10-22 15:54:56', '2015-01-01 00:00:00');
COMMIT;

-- ----------------------------
--  Records of `balance_sheet` 
-- ----------------------------
BEGIN;



insert  into `balance_sheet`(`id`,`code`,`parent_code`,`name`,`year_begin_exp`,`period_end_exp`,`need_sum`,`level`,`create_time`,`modify_time`) values (2,1101,11,'货币资金','<1001:1012>.C@1','<1001:1012>',0,2,'2015-10-28 14:11:01','2015-10-29 11:47:32'),(3,1102,11,'交易性金融资产','<1101>.C@1','<1101>',0,2,'2015-10-28 14:11:07','2015-10-28 14:37:22'),(4,1103,11,'应收票据','<1121>.C@1','<1121>',0,2,'2015-10-28 14:11:37','2015-10-28 14:37:20'),(5,1104,11,'应收账款','<1122>.C@1+<2203>.JC@1-<123101>.C@1','<1122>+<2203>.JC-<123101>',0,2,'2015-10-28 14:11:55','2015-10-29 12:00:08'),(6,1105,11,'预付款项','<1123>.C@1+<2202>.JC@1','<1123>+<2202>.JC',0,2,'2015-10-28 14:12:09','2015-10-29 12:00:16'),(7,1106,11,'应收利息','<1132>.C@1','<1132>',0,2,'2015-10-28 14:12:17','2015-10-28 14:37:19'),(8,1107,11,'应收股利','<1131>.C@1','<1131>',0,2,'2015-10-28 14:12:22','2015-10-28 14:37:19'),(9,1108,11,'其他应收款','<1221>.C@1-<123102>.C@1','<1221>-<123102>',0,2,'2015-10-28 14:12:27','2015-10-29 12:00:25'),(10,1109,11,'存货','<1321:1406>.C@1-<1407>.C@1+<1408:1411>.C@1-<1471>.C@1','<1321:1406>-<1407>+<1408:1411>-<1471>',0,2,'2015-10-28 14:12:32','2015-10-29 12:00:37'),(11,1110,11,'一年内到期的非流动资产','','',0,2,'2015-10-28 14:12:40','2015-10-29 10:53:06'),(12,1111,11,'其他流动资产','','',0,2,'2015-10-28 14:12:45','2015-10-29 10:53:09'),(14,1201,12,'可供出售金融资产','<1503>.C@1','<1503>',0,2,'2015-10-28 14:12:58','2015-10-28 14:37:18'),(15,1202,12,'持有至到期投资','<1501>.C@1-<1502>.C@1','<1501>-<1502>',0,2,'2015-10-28 14:13:03','2015-10-29 12:00:45'),(16,1203,12,'长期应收款','<1531>.C@1','<1531>',0,2,'2015-10-28 14:13:08','2015-10-28 14:37:18'),(17,1204,12,'长期股权投资','<1511>.C@1-<1512>.C@1','<1511>-<1512>',0,2,'2015-10-28 14:13:12','2015-10-29 12:00:51'),(18,1205,12,'投资性房地产','<1521>.C@1','<1521>',0,2,'2015-10-28 14:13:17','2015-10-28 14:37:25'),(19,1206,12,'固定资产','<1601>.C@1-<1602>.C@1-<1603>.C@1','<1601>-<1602>-<1603>',0,2,'2015-10-28 14:13:22','2015-10-29 11:59:42'),(20,1207,12,'在建工程','<1604>.C@1','<1604>',0,2,'2015-10-28 14:13:26','2015-10-28 14:37:17'),(21,1208,12,'工程物资','<1605>.C@1','<1605>',0,2,'2015-10-28 14:13:35','2015-10-28 14:37:17'),(22,1209,12,'固定资产清理','<1606>.C@1','<1606>',0,2,'2015-10-28 14:13:41','2015-10-28 14:37:17'),(23,1210,12,'生产性生物资产','','',0,2,'2015-10-28 14:13:45','2015-10-29 10:53:11'),(24,1211,12,'油气资产','','',0,2,'2015-10-28 14:13:50','2015-10-29 10:53:13'),(25,1212,12,'无形资产','<1701>.C@1-<1702>.C@1-<1703>.C@1','<1701>-<1702>-<1703>',0,2,'2015-10-28 14:14:09','2015-10-29 11:58:26'),(26,1213,12,'开发支出','','',0,2,'2015-10-28 14:14:18','2015-10-29 10:53:16'),(27,1214,12,'商誉','<1711>.C@1','<1711>',0,2,'2015-10-28 14:14:22','2015-10-28 14:37:16'),(28,1215,12,'长期待摊费用','<1801>.C@1','<1801>',0,2,'2015-10-28 14:14:28','2015-10-28 14:37:16'),(29,1216,12,'递延所得税资产','<1811>.C@1','<1811>',0,2,'2015-10-28 14:14:32','2015-10-28 14:37:28'),(30,1217,12,'其他非流动资产','<1532>.C@1+<1901>.C@1','<1532>+<1901>',0,2,'2015-10-28 14:15:06','2015-10-29 12:00:57'),(33,2101,21,'短期借款','<2001>.C@1','<2001>',0,2,'2015-10-28 14:15:57','2015-10-28 14:37:15'),(34,2102,21,'交易性金融负债','<2101>.C@1','<2101> ',0,2,'2015-10-28 14:16:02','2015-10-28 14:37:15'),(35,2103,21,'应付票据','<2201>.C@1','<2201>',0,2,'2015-10-28 14:16:06','2015-10-28 14:37:15'),(36,2104,21,'应付账款','<2202>.C@1+<1123>.DC@1','<2202>+<1123>.DC',0,2,'2015-10-28 14:16:10','2015-10-28 14:37:15'),(37,2105,21,'预收款项','<2203>.C@1+<1122>.DC@1','<2203>+<1122>.DC',0,2,'2015-10-28 14:16:14','2015-10-28 14:37:15'),(38,2106,21,'应付职工薪酬','<2211>.C@1','<2211>',0,2,'2015-10-28 14:16:18','2015-10-28 14:37:14'),(39,2107,21,'应交税费','<2221>.C@1','<2221>',0,2,'2015-10-28 14:16:22','2015-10-28 14:37:14'),(40,2108,21,'应付利息','<2232>.C@1','<2232>',0,2,'2015-10-28 14:16:25','2015-10-28 14:37:14'),(41,2109,21,'应付股利','<2231>.C@1','<2231>',0,2,'2015-10-28 14:16:30','2015-10-28 14:37:14'),(42,2110,21,'其他应付款','<2241>.C@1','<2241>',0,2,'2015-10-28 14:16:34','2015-10-28 14:37:14'),(43,2111,21,'一年内到期的非流动负债','','',0,2,'2015-10-28 14:16:40','2015-10-29 10:53:20'),(44,2112,21,'其他流动负债','<2314:2401>.C@1','<2314:2401>',0,2,'2015-10-28 14:16:45','2015-10-28 14:37:13'),(46,2201,22,'长期借款','<2501>.C@1','<2501>',0,2,'2015-10-28 14:16:50','2015-10-28 14:37:13'),(47,2202,22,'应付债券','<2502>.C@1','<2502>',0,2,'2015-10-28 14:16:54','2015-10-28 14:37:32'),(48,2203,22,'长期应付款','<2701>.C@1','<2701>',0,2,'2015-10-28 14:16:58','2015-10-28 14:37:12'),(49,2204,22,'专项应付款','<2711>.C@1','<2711>',0,2,'2015-10-28 14:17:02','2015-10-28 14:37:12'),(50,2205,22,'预计负债','<2801>.C@1','<2801>',0,2,'2015-10-28 14:17:06','2015-10-28 14:37:11'),(51,2206,22,'递延所得税负债','<2901>.C@1','<2901>',0,2,'2015-10-28 14:17:11','2015-10-28 14:37:11'),(52,2207,22,'其他非流动负债','<2702>.C@1','<2702>',0,2,'2015-10-28 14:17:14','2015-10-28 14:37:11'),(54,2301,23,'实收资本（或股本）','<4001>.C@1','<4001>',0,2,'2015-10-28 14:17:40','2015-10-28 14:37:10'),(55,2302,23,'资本公积','<4002>.C@1','<4002>',0,2,'2015-10-28 14:17:45','2015-10-28 14:37:10'),(56,2303,23,'减：库存股','<4201>.C@1','<4201>',1,2,'2015-10-28 14:17:49','2015-10-28 14:37:09'),(57,2304,23,'盈余公积','<4101>.C@1','<4101>',0,2,'2015-10-28 14:17:53','2015-10-28 14:37:09'),(58,2305,23,'未分配利润','<4103>.C@1+<4104>.C@1','<4103>+<4104>',0,2,'2015-10-28 14:17:59','2015-10-28 14:37:08'),(59,1,-9999,'资产','','',0,0,'2015-10-28 14:19:04','2015-10-28 16:41:53'),(60,2,-9999,'负债和所有者权益(或股东权益)','','',0,0,'2015-10-28 14:19:37','2015-10-28 14:36:59'),(61,11,1,'流动资产','','',0,1,'2015-10-28 14:20:34','2015-10-28 14:37:01'),(62,12,1,'非流动资产','','',0,1,'2015-10-28 14:20:49','2015-10-28 14:37:01'),(63,21,2,'流动负债','','',0,1,'2015-10-28 14:21:43','2015-10-28 14:37:02'),(64,22,2,'非流动负债','','',0,1,'2015-10-28 14:21:48','2015-10-28 14:37:02'),(65,23,2,'所有者权益（或股东权益）','','',0,1,'2015-10-28 14:22:36','2015-10-28 14:37:03'),(66,NULL,NULL,NULL,'','',0,NULL,'2015-10-28 14:37:36','2015-01-01 00:00:00');

commit;

-- ----------------------------
--  Records of `profit_template` 
-- ----------------------------
BEGIN;
insert  into `profit_template`(`id`,`name`,`month_exp`,`last_month_exp`,`create_time`,`modify_time`) values (1,'项目','本期金额','上期金额','0000-00-00 00:00:00','2015-11-02 10:25:30'),(2,'一、营业收入','=<6001>.SY+<6051>.SY','=<6001>.SY@-1+<6051>.SY@-1','0000-00-00 00:00:00','2015-11-02 10:25:30'),(3,'减：营业成本','=<6401>.SY+<6402>.SY','=<6401>.SY@-1+<6402>.SY@-1','0000-00-00 00:00:00','2015-11-02 10:25:30'),(4,'　　营业税金及附加','=<6403>.SY','=<6403>.SY@-1','0000-00-00 00:00:00','2015-11-02 10:25:30'),(5,'　　销售费用','=<6601>.SY','=<6601>.SY@-1','0000-00-00 00:00:00','2015-11-02 10:25:30'),(6,'　　管理费用','=<6602>.SY','=<6602>.SY@-1','0000-00-00 00:00:00','2015-11-02 10:25:30'),(7,'　　财务费用','=<6603>.SY','=<6603>.SY@-1','0000-00-00 00:00:00','2015-11-02 10:25:30'),(8,'　　资产减值损失','=<6701>.SY','=<6701>.SY@-1','0000-00-00 00:00:00','2015-11-02 10:25:30'),(9,'加：公允价值变动收益（损失以“-”号填列）','=<6101>.SY','=<6101>.SY@-1','0000-00-00 00:00:00','2015-11-02 10:25:30'),(10,'　　投资收益（损失以“-”号填列）','=<6111>.SY','=<6111>.SY@-1','0000-00-00 00:00:00','2015-11-02 10:25:30'),(11,'二、营业利润（损失以“-”号填列）','=B2-B3-B4-B5-B6-B7-B8+B9+B10','=C2-C3-C4-C5-C6-C7-C8+C9+C10','0000-00-00 00:00:00','2015-11-02 10:25:30'),(12,'加：营业外收入','=<6301>.SY','=<6301>.SY@-1','0000-00-00 00:00:00','2015-11-02 10:25:30'),(13,'减：营业外支出','=<6711>.SY','=<6711>.SY@-1','0000-00-00 00:00:00','2015-11-02 10:25:30'),(14,'三、利润总额（损失以“-”号填列）','=B11+B12-B13','=C11+C12-C13','0000-00-00 00:00:00','2015-11-02 10:25:30'),(15,'减：所得税费用','=<6801>.SY','=<6801>.SY@-1','0000-00-00 00:00:00','2015-11-02 10:25:30'),(16,'四、净利润','=B14-B15','=C14-C15','0000-00-00 00:00:00','2015-11-02 10:25:30');
commit;



-- ----------------------------
--  Records of `cash_flow_sheet`
-- ----------------------------
BEGIN;
insert  into `cash_flow_sheet`(`id`,`name`,`auxiliary_exp`,`real_exp`,`create_time`,`modify_time`) values (1,'项目','','本期金额','2015-11-16 11:33:58','2015-01-01 00:00:00'),(2,'一、经营活动产生的现金流量：','','','2015-11-16 11:33:58','2015-01-01 00:00:00'),(3,'　　销售商品、提供劳务收到的现金','','=ACCT(\"6001\",\"SY\",\"\",0,0,0,\"\")*1.17+ACCT(\"6051\",\"SY\",\"\",0,0,0,\"\")+ACCT(\"1122\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1122\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1121\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1121\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"2203\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"2203\",\"C\",\"\",0,0,0,\"\")','2015-11-16 11:33:58','2015-01-01 00:00:00'),(4,'　　收到的税费返还','','','2015-11-16 11:33:58','2015-01-01 00:00:00'),(5,'　　收到的其他与经营活动有关的现金','','=C69-C3-C4+C11-C25-C35-C36','2015-11-16 11:33:58','2015-01-01 00:00:00'),(6,'　　　现金流入小计','','=C3+C4+C5','2015-11-16 11:33:59','2015-01-01 00:00:00'),(7,'　　购买商品、接受劳务支付的现金','','=ACCT(\"6401\",\"JF\",\"\",0,0,0,\"\")*1.17+ACCT(\"6402\",\"JF\",\"\",0,0,0,\"\")+ACCT(\"1321\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1321\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1401:1406\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1401:1406\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1408\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1408\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1407\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1407\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1411\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1411\",\"C\",\"\",0,0,0,\"\")+ACCT(\"5001\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"5001\",\"C\",\"\",0,0,0,\"\")+ACCT(\"5201\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"5201\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1471\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1471\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"2201\",\"C\",\"\",0,0,0,\"\")-ACCT(\"2201\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"2202\",\"C\",\"\",0,0,0,\"\")-ACCT(\"2202\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1123\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1123\",\"C\",\"\",0,0,0,\"\")','2015-11-16 11:33:59','2015-01-01 00:00:00'),(8,'　　支付给职工以及为职工支付的现金','','=ACCT(\"2211\",\"JF\",\"\",0,0,0,\"\")','2015-11-16 11:33:59','2015-01-01 00:00:00'),(9,'　　支付的各项税费','','=ACCT(\"2221\",\"JF\",\"\",0,0,0,\"\")','2015-11-16 11:33:59','2015-01-01 00:00:00'),(10,'　　支付的其他与经营活动有关的现金','=ACCT(\"6711\",\"SY\",\"\",0,0,0,\"\")+ACCT(\"6601\",\"SY\",\"\",0,0,0,\"\")+ACCT(\"6602\",\"SY\",\"\",0,0,0,\"\")+ACCT(\"6603\",\"SY\",\"\",0,0,0,\"\")+ACCT(\"6701\",\"SY\",\"\",0,0,0,\"\")-ACCT(\"1702\",\"DF\",\"\",0,0,0,\"\")-ACCT(\"1602\",\"DF\",\"\",0,0,0,\"\")-ACCT(\"1603\",\"DF\",\"\",0,0,0,\"\")-ACCT(\"1703\",\"DF\",\"\",0,0,0,\"\")-ACCT(\"1502\",\"DF\",\"\",0,0,0,\"\")-ACCT(\"1512\",\"DF\",\"\",0,0,0,\"\")-ACCT(\"2211\",\"DF\",\"\",0,0,0,\"\")+ACCT(\"1901\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1901\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1811\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1811\",\"C\",\"\",0,0,0,\"\")-ACCT(\"2241\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"2241\",\"C\",\"\",0,0,0,\"\")-ACCT(\"2901\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"2901\",\"C\",\"\",0,0,0,\"\")-ACCT(\"2401\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"2401\",\"C\",\"\",0,0,0,\"\")','=IF(\"B10>0\",B10,0)','2015-11-16 11:33:59','2015-01-01 00:00:00'),(11,'　　　现金流出小计','','=SUM(C7:C10)','2015-11-16 11:33:59','2015-01-01 00:00:00'),(12,'　　　经营活动产生的现金流量净额','','=C6-C11','2015-11-16 11:33:59','2015-01-01 00:00:00'),(13,'二、投资活动产生的现金流量：','','','2015-11-16 11:33:59','2015-01-01 00:00:00'),(14,'　　收回投资所收到的现金','=-ACCT(\"1101\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1101\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1501\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1501\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1503\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1503\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1511\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1511\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1521\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1521\",\"C\",\"\",0,0,0,\"\")+ACCT(\"6101\",\"SY\",\"\",0,0,0,\"\")','=IF(\"B14>0\",B14,0)','2015-11-16 11:34:00','2015-01-01 00:00:00'),(15,'　　取得投资收益所收到的现金','','=ACCT(\"6111\",\"SY\",\"\",0,0,0,\"\")-ACCT(\"1131\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1131\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1132\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1132\",\"C\",\"\",0,0,0,\"\")','2015-11-16 11:34:00','2015-01-01 00:00:00'),(16,'　　处置固定资产、无形资产和其他长期资产所收回的现金净额','','=ACCT(\"1606\",\"DF\",\"\",0,0,0,\"\")','2015-11-16 11:34:00','2015-01-01 00:00:00'),(17,'　　处置子公司及其他营业单位收到的现金净额','','','2015-11-16 11:34:00','2015-01-01 00:00:00'),(18,'　　收到的其他与投资活动有关的现金','','','2015-11-16 11:34:00','2015-01-01 00:00:00'),(19,'　　　现金流入小计','','=SUM(C14:C18)','2015-11-16 11:34:00','2015-01-01 00:00:00'),(20,'　　购建固定资产、无形资产和其他长期资产所支付的现金','','=ACCT(\"1601\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1601\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1604\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1604\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1605\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1605\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1701\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1701\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1711\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1711\",\"C\",\"\",0,0,0,\"\")','2015-11-16 11:34:00','2015-01-01 00:00:00'),(21,'　　投资所支付的现金','=ACCT(\"1101\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1101\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1501\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1501\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1503\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1503\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1511\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1511\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1521\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1521\",\"C\",\"\",0,0,0,\"\")-ACCT(\"6101\",\"SY\",\"\",0,0,0,\"\")','=IF(\"B21>0\",B21,0)','2015-11-16 11:34:01','2015-01-01 00:00:00'),(22,'　　取得子公司及其他营业单位支付的现金净额','','','2015-11-16 11:34:01','2015-01-01 00:00:00'),(23,'　　支付的其他与投资活动有关的现金','','','2015-11-16 11:34:01','2015-01-01 00:00:00'),(24,'　　　现金流出小计','','=SUM(C20:C23)','2015-11-16 11:34:01','2015-01-01 00:00:00'),(25,'　　　投资活动产生的现金流量净额','','=C19-C24','2015-11-16 11:34:01','2015-01-01 00:00:00'),(26,'三、筹资活动产生的现金流量：','','','2015-11-16 11:34:01','2015-01-01 00:00:00'),(27,'　　吸收投资所收到的现金','','=ACCT(\"4001\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"4001\",\"C\",\"\",0,0,0,\"\")','2015-11-16 11:34:01','2015-01-01 00:00:00'),(28,'　　取得借款收到的现金','=ACCT(\"2001\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"2001\",\"C\",\"\",0,0,0,\"\")+ACCT(\"2501\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"2501\",\"C\",\"\",0,0,0,\"\")+ACCT(\"2101\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"2101\",\"C\",\"\",0,0,0,\"\")+ACCT(\"2701\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"2701\",\"C\",\"\",0,0,0,\"\")+ACCT(\"2711\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"2711\",\"C\",\"\",0,0,0,\"\")+ACCT(\"2502\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"2502\",\"C\",\"\",0,0,0,\"\")','=IF(\"B28>0\",B28,0)','2015-11-16 11:34:02','2015-01-01 00:00:00'),(29,'　　收到的其他与筹资活动有关的现金','','','2015-11-16 11:34:02','2015-01-01 00:00:00'),(30,'　　　现金流入小计','','=SUM(C27:C29)','2015-11-16 11:34:02','2015-01-01 00:00:00'),(31,'　　偿还债务所支付的现金','=-ACCT(\"2001\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"2001\",\"C\",\"\",0,0,0,\"\")-ACCT(\"2501\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"2501\",\"C\",\"\",0,0,0,\"\")-ACCT(\"2101\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"2101\",\"C\",\"\",0,0,0,\"\")-ACCT(\"2701\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"2701\",\"C\",\"\",0,0,0,\"\")-ACCT(\"2711\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"2711\",\"C\",\"\",0,0,0,\"\")-ACCT(\"2502\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"2502\",\"C\",\"\",0,0,0,\"\")','=IF(\"B31>0\",B31,0)','2015-11-16 11:34:02','2015-01-01 00:00:00'),(32,'　　分配股利、利润或偿付利息所支付的现金','','=-ACCT(\"2231\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"2231\",\"C\",\"\",0,0,0,\"\")-ACCT(\"2232\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"2232\",\"C\",\"\",0,0,0,\"\")','2015-11-16 11:34:02','2015-01-01 00:00:00'),(33,'　　支付的其他与筹资活动有关的现金','','','2015-11-16 11:34:02','2015-01-01 00:00:00'),(34,'　　　现金流出小计','','=SUM(C31:C33)','2015-11-16 11:34:02','2015-01-01 00:00:00'),(35,'　　　筹资活动产生的现金流量净额','','=C30-C34','2015-11-16 11:34:02','2015-01-01 00:00:00'),(36,'四、汇率变动对现金的影响','','','2015-11-16 11:34:03','2015-01-01 00:00:00'),(37,'五、现金及现金等价物净增加额','','=C12+C25+C35+C36','2015-11-16 11:34:03','2015-01-01 00:00:00'),(38,'加：期初现金及现金等价物余额','','=ACCT(\"1001\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1002\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1012\",\"C\",\"\",0,0,0,\"\")','2015-11-16 11:34:03','2015-01-01 00:00:00'),(39,'六、期末现金及现金等价物余额','','=ACCT(\"1001\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1002\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1012\",\"Y\",\"\",0,0,0,\"\")','2015-11-16 11:34:03','2015-01-01 00:00:00'),(40,'补充资料','','','2015-11-16 11:34:03','2015-01-01 00:00:00'),(41,'现金流量表附表项目','','','2015-11-16 11:34:03','2015-01-01 00:00:00'),(42,'1.将净利润调节为经营活动现金流量','','','2015-11-16 11:34:03','2015-01-01 00:00:00'),(43,'　　净利润','','=ACCT(\"4103\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"4103\",\"C\",\"\",0,0,0,\"\")','2015-11-16 11:34:03','2015-01-01 00:00:00'),(44,'　　资产减值准备','','=ACCT(\"1502\",\"DF\",\"\",0,0,0,\"\")+ACCT(\"1512\",\"DF\",\"\",0,0,0,\"\")+ACCT(\"1603\",\"DF\",\"\",0,0,0,\"\")+ACCT(\"1703\",\"DF\",\"\",0,0,0,\"\")','2015-11-16 11:34:03','2015-01-01 00:00:00'),(45,'　　固定资产折旧、油气资产折耗、生产性生物资产折旧','','=ACCT(\"1602\",\"DF\",\"\",0,0,0,\"\")','2015-11-16 11:34:04','2015-01-01 00:00:00'),(46,'　　无形资产摊销','','=ACCT(\"1702\",\"DF\",\"\",0,0,0,\"\")','2015-11-16 11:34:04','2015-01-01 00:00:00'),(47,'　　长期待摊费用摊销','','=ACCT(\"1801\",\"DF\",\"\",0,0,0,\"\")','2015-11-16 11:34:04','2015-01-01 00:00:00'),(48,'　　处理固定资产、无形资产和其他长期资产的损失','','','2015-11-16 11:34:04','2015-01-01 00:00:00'),(49,'　　固定资产报废损失','','','2015-11-16 11:34:04','2015-01-01 00:00:00'),(50,'　　公允价值变动损失','','=-ACCT(\"6101\",\"SY\",\"\",0,0,0,\"\")','2015-11-16 11:34:05','2015-01-01 00:00:00'),(51,'　　财务费用','','=ACCT(\"6603\",\"SY\",\"\",0,0,0,\"\")','2015-11-16 11:34:05','2015-01-01 00:00:00'),(52,'　　投资损失','','=-ACCT(\"6111\",\"SY\",\"\",0,0,0,\"\")','2015-11-16 11:34:05','2015-01-01 00:00:00'),(53,'　　递延所得税资产减少','','=-ACCT(\"1811\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1811\",\"C\",\"\",0,0,0,\"\")','2015-11-16 11:34:05','2015-01-01 00:00:00'),(54,'　　递延所得税负债增加','','=ACCT(\"2901\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"2901\",\"C\",\"\",0,0,0,\"\")','2015-11-16 11:34:05','2015-01-01 00:00:00'),(55,'　　存货的减少','','=-ACCT(\"1321\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1321\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1401:1406\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1401:1406\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1408\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1408\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1407\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1407\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1411\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1411\",\"C\",\"\",0,0,0,\"\")-ACCT(\"5001\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"5001\",\"C\",\"\",0,0,0,\"\")-ACCT(\"5201\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"5201\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1471\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"1471\",\"C\",\"\",0,0,0,\"\")','2015-11-16 11:34:05','2015-01-01 00:00:00'),(56,'　　经营性应收项目的减少','','=-ACCT(\"1121\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1121\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1231\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1231\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1122\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1122\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1123\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1123\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1221\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1221\",\"C\",\"\",0,0,0,\"\")-ACCT(\"1901\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1901\",\"C\",\"\",0,0,0,\"\")','2015-11-16 11:34:05','2015-01-01 00:00:00'),(57,'　　经营性应付项目的增加','','=ACCT(\"2201\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"2201\",\"C\",\"\",0,0,0,\"\")+ACCT(\"2202\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"2202\",\"C\",\"\",0,0,0,\"\")+ACCT(\"2203\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"2203\",\"C\",\"\",0,0,0,\"\")+ACCT(\"2211\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"2211\",\"C\",\"\",0,0,0,\"\")+ACCT(\"2221\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"2221\",\"C\",\"\",0,0,0,\"\")+ACCT(\"2241\",\"Y\",\"\",0,0,0,\"\")-ACCT(\"2241\",\"C\",\"\",0,0,0,\"\")','2015-11-16 11:34:05','2015-01-01 00:00:00'),(58,'　　其他','','=C12-SUM(C43:C57)','2015-11-16 11:34:06','2015-01-01 00:00:00'),(59,'　　　经营活动产生的现金流量净额','','=SUM(C43:C58)','2015-11-16 11:34:06','2015-01-01 00:00:00'),(60,'2.不涉及现金收支的投资和筹资活动','','','2015-11-16 11:34:06','2015-01-01 00:00:00'),(61,'　　债务转为资本','','','2015-11-16 11:34:06','2015-01-01 00:00:00'),(62,'　　一年内到期的可转换公司债券','','','2015-11-16 11:34:07','2015-01-01 00:00:00'),(63,'　　融资租入固定资产','','','2015-11-16 11:34:07','2015-01-01 00:00:00'),(64,'3.现金及现金等价物净增加情况','','','2015-11-16 11:34:07','2015-01-01 00:00:00'),(65,'　　现金的期末余额','','=ACCT(\"1001\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1002\",\"Y\",\"\",0,0,0,\"\")+ACCT(\"1012\",\"Y\",\"\",0,0,0,\"\")','2015-11-16 11:34:07','2015-01-01 00:00:00'),(66,'　　减：现金的期初余额','','=ACCT(\"1001\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1002\",\"C\",\"\",0,0,0,\"\")+ACCT(\"1012\",\"C\",\"\",0,0,0,\"\")','2015-11-16 11:34:07','2015-01-01 00:00:00'),(67,'　　加：现金等价物的期末余额','','','2015-11-16 11:34:07','2015-01-01 00:00:00'),(68,'　　减：现金等价物的期初余额','','','2015-11-16 11:34:07','2015-01-01 00:00:00'),(69,'　　现金及现金等价物的净增加额','','=C65-C66+C67-C68','2015-11-16 11:34:08','2015-01-01 00:00:00');
commit;

-- 演示账套数据 ---


/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;



